package com.ruoyi.project.qyxy.qua.mapper;

import com.ruoyi.project.qyxy.qua.domain.OrgScoreTest;
import com.ruoyi.project.qyxy.qua.domain.QuaRule;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface QuaRuleMapper {

    @Select("select b.id,a.QUA_NAME as name,b.\"LEVEL\",b.SCORE from T_QUA_NAME_TYPE a,T_QUA_LEVEL_CONFIG b\n" +
            "where a.type = b.type \n" +
            "order by score+0 desc,b.type asc")
    List<QuaRule> selectList();
}
